Error: Run-time error 91...opening Excel file in Binder due to can't run macros.
Error:
Run-time error 91: Object variable not set. Range Method of Application Class failed.
Cause:
This error occurs when opening a binder or activating a section that contains an Excel file. The Excel file was created using a template that contains Visual Basic macros. These macros cannot be run within a Binder. Microsoft Corporation has confirmed this to be a problem in Office 95.
Solution:
Do not include an Excel file created from a template containing a macro in an Office Binder. To work around the problem, unbind the binder.
NOTE: If Binder hangs during the following procedure, press CTRL+ALT+DEL, select 'Microsoft Office Binders/Microsoft Excel' and click 'End Task'.
To unbind the binder:
1) Exit binder.
2) Open 'Windows Explorer' in Windows:
a) Click 'Start' todisplay the Windows 'Start' menu.
Start menu
b) Select the 'Start' menu and select 'Windows Explorer'.
3) Locate the Binder file:
a) Click 'Start' todisplay the Windows 'Start' menu.
b) Select 'Find' and select 'Files or Folders'.
c) Select 'Files or Folders...' from the submenu.
d) Click the 'Name and Location' tab.
e) Type the name of the Binder file in the 'Find What' box.
NOTE: If the complete name is not known, type *.OBD to search for all Binder files.
f) Click 'Find Now'. (The Binder file will appear in the search results window.)
4) Right-click on the binder file to display the shortcut menu.
Binder section shortcut menu
5) Select 'Unbind' from the shortcut menu.
6) Close the 'Find File' dialog box.
